

-- ----------------------------
-- Table structure for agriculture_baseinfo
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_baseinfo`;
CREATE TABLE `agriculture_baseinfo` (
  `base_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '基地ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `base_short_name` varchar(20) NOT NULL DEFAULT '' COMMENT '基地简称',
  `base_code` varchar(20) NOT NULL DEFAULT '' COMMENT '基地编号',
  `base_name` varchar(30) NOT NULL DEFAULT '' COMMENT '基地全称',
  `base_leader` varchar(10) NOT NULL DEFAULT '' COMMENT '基地负责人',
  `leader_tel` varchar(17) NOT NULL DEFAULT '' COMMENT '基地负责人电话',
  `base_address` varchar(500) NOT NULL DEFAULT '' COMMENT '基地负责人地址',
  `base_area` varchar(30) NOT NULL DEFAULT '' COMMENT '基地面积',
  `base_altitude` int(11) NOT NULL DEFAULT '0' COMMENT '基地海拔',
  `base_img` varchar(500) NOT NULL DEFAULT '' COMMENT '现场图片',
  `base_des` varchar(1000) NOT NULL DEFAULT '' COMMENT '基地描述',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `base_coordinate` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`base_id`)
) ENGINE=InnoDB COMMENT='基地信息表';

-- ----------------------------
-- Records of agriculture_baseinfo
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_baseinfo` (`base_id`, `base_short_name`, `base_code`, `base_name`, `base_leader`, `leader_tel`, `base_address`, `base_area`, `base_altitude`, `base_img`, `base_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (2, '方强农场', '001', '大丰方强农场', '张三', '19111111111', '江苏盐城', '3000', 5, '/profile/iot/1/2024-0307-163744.png', '省管农场', '', '0', 0, 0, '2023-05-17 08:22:14', 0, '2024-05-03 21:43:47', '0', '120.152634,33.35139');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_batch_task
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_batch_task`;
CREATE TABLE `agriculture_batch_task` (
  `task_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `create_dept` bigint DEFAULT NULL,
  `batch_id` bigint(20) unsigned DEFAULT NULL COMMENT '批次ID',
  `task_head` bigint(20) unsigned DEFAULT NULL COMMENT '任务负责人',
  `task_head_name` varchar(255) DEFAULT NULL,
  `task_name` varchar(50) NOT NULL DEFAULT '' COMMENT '任务名称',
  `plan_start` datetime DEFAULT NULL COMMENT '计划开始日期',
  `plan_finish` datetime DEFAULT NULL COMMENT '计划结束日期',
  `actual_start` datetime DEFAULT NULL COMMENT '实际开始日期',
  `actual_finish` datetime DEFAULT NULL COMMENT '实际结束日期',
  `task_detail` varchar(2000) NOT NULL DEFAULT '' COMMENT '任务详情',
  `task_images` text COMMENT '图片资料',
  `task_videos` text COMMENT '视频资料',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB COMMENT='批次任务表';

-- ----------------------------
-- Records of agriculture_batch_task
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 3, 3, '张三', '播种1', '2023-06-06 00:00:00', '2023-06-20 00:00:00', '2024-04-26 00:00:00', '2024-04-26 00:00:00', '', '/profile/upload/2024/05/02/33777d8c-f307-4355-9545-df1599b29cd5.jpg', '', 'e记得记得就好的好的基督教xx把bv你了哈哈哈', '1', 0, 0, NULL, 1, '2024-05-02 14:46:23', '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 3, NULL, NULL, '浇水1', '2023-06-13 00:00:00', '2023-06-27 00:00:00', '2024-04-24 00:00:00', '2024-04-28 00:00:00', '', NULL, '/profile/upload/2024/04/24/8f72cffd-e033-404a-92ec-bf3f2afba562.MOV', '', '3', 0, 0, NULL, 1, '2024-04-24 22:12:10', '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 3, NULL, NULL, '采摘', '2023-07-04 00:00:00', '2023-07-11 00:00:00', NULL, NULL, '', NULL, NULL, '', '3', 0, 0, NULL, 1, '2024-04-24 13:55:21', '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 4, 1, NULL, '育苗', '2023-06-06 00:00:00', '2023-06-20 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 1, '2023-08-14 09:26:44', '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 4, NULL, NULL, '铺膜', '2023-06-20 00:00:00', '2023-06-27 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 0, NULL, '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 4, NULL, NULL, '育苗完成', '2023-07-04 00:00:00', '2023-07-11 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 0, NULL, '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, 4, NULL, NULL, '定植', '2023-07-11 00:00:00', '2023-07-18 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 0, NULL, '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, 4, NULL, NULL, '植保防护', '2023-07-18 00:00:00', '2023-07-25 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 0, NULL, '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (99, 43, 1, NULL, '结果期', '2024-05-03 00:00:00', '2024-08-04 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 1, '2024-05-03 22:40:06', '0');
INSERT INTO `agriculture_batch_task` (`task_id`, `batch_id`, `task_head`, `task_head_name`, `task_name`, `plan_start`, `plan_finish`, `actual_start`, `actual_finish`, `task_detail`, `task_images`, `task_videos`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (100, 43, 1, NULL, '采摘', '2024-08-04 00:00:00', '2024-08-11 00:00:00', NULL, NULL, '', NULL, NULL, '', '0', 0, 0, NULL, 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_cost_employee
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_cost_employee`;
CREATE TABLE `agriculture_cost_employee` (
  `cost_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `create_dept` bigint DEFAULT NULL,
  `task_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `employee_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '雇员ID',
  `working_hours` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '工时',
  `working_start` datetime DEFAULT NULL COMMENT '开始日期',
  `working_finish` datetime DEFAULT NULL COMMENT '结束日期',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`cost_id`)
) ENGINE=InnoDB COMMENT='人工工时表';

-- ----------------------------
-- Records of agriculture_cost_employee
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 76, 1, 35.00, '2023-06-05 00:00:00', '2023-06-15 00:00:00', '', '0', 0, 1, '2023-06-12 09:46:53', 1, '2023-06-13 09:10:37', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 1, 1, 3.00, '2023-05-29 00:00:00', '2023-06-13 00:00:00', '', '0', 0, 1, '2023-06-12 09:58:27', 1, '2023-09-26 17:04:28', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 1, 3, 1.00, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2023-08-21 16:42:01', 1, '2023-09-14 09:01:30', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 76, 1, 10.00, '2023-08-01 00:00:00', '2023-08-08 00:00:00', '', '0', 0, 8, '2023-08-27 15:35:32', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 88, 1, 1.00, '2023-10-02 00:00:00', '2023-10-03 00:00:00', '', '0', 0, 1, '2023-10-09 16:11:12', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 0, 3, 10.00, '2024-04-25 00:00:00', '2024-04-26 00:00:00', '', '0', 0, 1, '2024-04-24 10:41:10', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, 0, 1, 100.00, '2024-04-24 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-24 10:42:22', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, 0, 1, 223.00, '2024-04-24 00:00:00', '2024-05-02 00:00:00', '', '0', 0, 1, '2024-04-24 10:55:30', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, 1, 3, 1.00, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2024-04-24 10:56:00', 1, '2023-09-14 09:01:30', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, 1, 3, 1.00, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2024-04-24 10:58:49', 1, '2023-09-14 09:01:30', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (11, 1, 3, 200.00, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2024-04-24 11:16:00', 1, '2024-04-25 20:14:36', '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12, 1, 3, 30000.00, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2024-04-24 11:16:17', 1, '2023-09-14 09:01:30', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (13, 1, 3, 996122.43, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2024-04-24 11:18:38', 1, '2024-04-24 11:23:00', '2');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (14, 0, 0, 20.00, '2024-04-24 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-24 12:32:58', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (15, 0, 1, 689.00, '2024-04-25 00:00:00', '2024-05-03 00:00:00', '', '0', 0, 1, '2024-04-25 20:12:59', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (16, 0, 1, 67.00, '2024-04-24 00:00:00', '2024-05-02 00:00:00', '', '0', 0, 1, '2024-04-25 20:13:25', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (17, 0, 1, 123.00, '2024-04-25 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-25 20:15:38', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (18, 0, 1, 10.00, '2024-05-09 00:00:00', '2024-05-10 00:00:00', '', '0', 0, 1, '2024-04-25 20:17:16', 0, NULL, '0');
INSERT INTO `agriculture_cost_employee` (`cost_id`, `task_id`, `employee_id`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (19, 1, 1, 10.00, '2024-04-23 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-25 20:21:32', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_cost_machine
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_cost_machine`;
CREATE TABLE `agriculture_cost_machine` (
  `cost_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `create_dept` bigint DEFAULT NULL,
  `task_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `machine_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '机械ID',
  `machine_count` int(11) NOT NULL DEFAULT '0' COMMENT '机械数量',
  `working_hours` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '工时',
  `working_start` datetime DEFAULT NULL COMMENT '开始日期',
  `working_finish` datetime DEFAULT NULL COMMENT '结束日期',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`cost_id`)
) ENGINE=InnoDB COMMENT='机械工时表';

-- ----------------------------
-- Records of agriculture_cost_machine
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 76, 1, 1, 1.00, '2023-06-13 00:00:00', '2023-06-06 00:00:00', '', '0', 0, 1, '2023-06-13 09:55:48', 0, NULL, '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 1, 1, 6, 1.50, '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2023-08-21 10:22:38', 1, '2023-09-12 14:18:59', '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 1, 1, 2, 1.50, '2023-08-21 00:00:00', '2023-08-23 00:00:00', '', '0', 0, 1, '2023-08-21 17:02:09', 1, '2023-09-12 14:19:05', '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 76, 1, 10, 1.00, '2023-08-01 00:00:00', '2023-08-09 00:00:00', '', '0', 0, 8, '2023-08-27 15:35:48', 0, NULL, '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 1, 1, 2, 100.00, '2024-04-22 00:00:00', '2024-04-24 00:00:00', '', '0', 0, 1, '2024-04-22 19:49:19', 1, '2024-04-25 20:14:57', '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 1, 1, 1, 9.00, '2024-04-22 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-22 19:53:43', 0, NULL, '2');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, 1, 1, 23, 23.00, '2024-04-09 00:00:00', '2024-04-10 00:00:00', '', '0', 0, 1, '2024-04-24 11:36:11', 0, NULL, '2');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, 0, 1, 333, 100.00, '2024-05-01 00:00:00', '2024-05-02 00:00:00', '', '0', 0, 1, '2024-04-24 12:38:38', 1, '2024-04-24 12:40:06', '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, 0, 1, 456, 567.00, '2024-04-25 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-25 20:13:59', 0, NULL, '0');
INSERT INTO `agriculture_cost_machine` (`cost_id`, `task_id`, `machine_id`, `machine_count`, `working_hours`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, 1, 1, 67, 110.00, '2024-05-08 00:00:00', '2024-05-09 00:00:00', '', '0', 0, 1, '2024-04-25 20:24:10', 1, '2024-04-25 20:24:27', '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_cost_material
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_cost_material`;
CREATE TABLE `agriculture_cost_material` (
  `cost_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `task_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `material_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '农资ID',
  `material_count` int(11) NOT NULL DEFAULT '0' COMMENT '使用数量',
  `measure_unit` varchar(10) NOT NULL DEFAULT '' COMMENT '计量单位',
  `working_start` datetime DEFAULT NULL COMMENT '开始日期',
  `working_finish` datetime DEFAULT NULL COMMENT '结束日期',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`cost_id`)
) ENGINE=InnoDB  COMMENT='农资用量表';

-- ----------------------------
-- Records of agriculture_cost_material
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 76, 1, 1, '袋', '2023-06-05 00:00:00', '2023-06-13 00:00:00', '', '0', 0, 1, '2023-06-13 10:24:01', 0, NULL, '2');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 1, 1, 3, '袋', '2023-08-21 00:00:00', '2023-08-22 00:00:00', '', '0', 0, 1, '2023-08-21 16:51:45', 1, '2023-09-11 15:10:33', '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 0, 2, 1, '袋', '2023-08-21 00:00:00', '2023-08-23 00:00:00', '', '0', 0, 1, '2023-08-21 17:00:33', 0, NULL, '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 0, 3, 1, '把', '2023-08-28 00:00:00', '2023-08-30 00:00:00', '', '0', 0, 1, '2023-08-21 17:03:49', 0, NULL, '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 1, 3, 1, '把', '2023-08-21 00:00:00', '2023-08-23 00:00:00', '', '0', 0, 1, '2023-08-21 17:04:26', 0, NULL, '2');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 0, 1, 1, '袋', '2023-08-22 00:00:00', '2023-08-31 00:00:00', '', '0', 0, 1, '2023-08-21 17:05:33', 0, NULL, '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, 1, 3, 1, '把', '2023-08-21 00:00:00', '2023-08-24 00:00:00', '', '0', 0, 1, '2023-08-21 17:07:55', 0, NULL, '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, 76, 3, 10, '袋', '2023-08-01 00:00:00', '2023-08-15 00:00:00', '', '0', 0, 8, '2023-08-27 15:36:07', 0, NULL, '2');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, 88, 2, 1, '1', '2023-10-02 00:00:00', '2023-10-10 00:00:00', '', '0', 0, 1, '2023-10-09 16:12:21', 0, NULL, '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, 1, 1, 222, '带', '2024-04-24 00:00:00', '2024-04-25 00:00:00', '', '0', 0, 1, '2024-04-24 12:41:22', 0, NULL, '2');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (11, 0, 4, 100, '把', '2024-04-24 00:00:00', '2024-05-11 00:00:00', '', '0', 0, 1, '2024-04-24 12:52:28', 1, '2024-04-24 12:56:30', '0');
INSERT INTO `agriculture_cost_material` (`cost_id`, `task_id`, `material_id`, `material_count`, `measure_unit`, `working_start`, `working_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12, 1, 3, 30, '把', '2024-05-08 00:00:00', '2024-05-09 00:00:00', '', '0', 0, 1, '2024-04-25 20:25:03', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_crop_batch
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_crop_batch`;
CREATE TABLE `agriculture_crop_batch` (
  `batch_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '批次ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `batch_name` varchar(50) NOT NULL COMMENT '批次名称',
  `germplasm_id` bigint(20) NOT NULL COMMENT '种质ID',
  `land_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '地块ID',
  `crop_area` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '种植面积（亩）',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `batch_head` bigint(20) NOT NULL DEFAULT '0' COMMENT '负责人Id',
  PRIMARY KEY (`batch_id`)
) ENGINE=InnoDB COMMENT='作物批次表';

-- ----------------------------
-- Records of agriculture_crop_batch
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (3, '好哥哥', 2, 1, 455.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 15:07:17', 1, '2024-04-22 13:48:03', '0', 0);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (4, '2023', 1, 3, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 17:43:31', 1, '2023-06-06 08:49:56', '0', 5);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (5, '202302', 1, 4, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 17:47:47', 1, '2023-06-06 08:49:50', '0', 2);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (6, '2023年番茄', 2, 1, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 15:07:17', 0, NULL, '0', 0);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (7, '2023年番茄', 2, 1, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 15:07:17', 0, NULL, '0', 0);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (8, '2023年番茄', 2, 1, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 15:07:17', 0, NULL, '0', 0);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (9, '2023年番茄', 2, 1, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 15:07:17', 0, NULL, '0', 0);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (10, '2023年番茄', 2, 1, 100.00, '2023-05-30 00:00:00', '', '0', 0, 1, '2023-05-30 15:07:17', 0, NULL, '0', 0);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (41, 'taskHead', 1, 1, 22.00, '2023-06-07 00:00:00', '', '0', 0, 1, '2023-06-10 15:10:49', 1, '2024-01-08 16:52:36', '0', 8);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (42, '测试完成11', 3, 5, 100.00, '2023-09-05 00:00:00', '', '1', 0, 1, '2023-09-05 12:55:12', 8, '2024-01-16 22:14:00', '0', 8);
INSERT INTO `agriculture_crop_batch` (`batch_id`, `batch_name`, `germplasm_id`, `land_id`, `crop_area`, `start_time`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `batch_head`) VALUES (43, '测试事务', 1, 1, 1000.00, '2024-04-21 00:00:00', '', '0', 0, 1, '2024-04-21 14:48:21', 0, NULL, '0', 1);
COMMIT;

-- ----------------------------
-- Table structure for agriculture_employee
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_employee`;
CREATE TABLE `agriculture_employee` (
  `employee_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '雇员ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `employee_code` varchar(20) NOT NULL DEFAULT '' COMMENT '编码',
  `employee_name` varchar(10) NOT NULL DEFAULT '' COMMENT '姓名',
  `employee_type` char(1) NOT NULL DEFAULT '0' COMMENT '字典 agriculture_employee_type',
  `employee_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码',
  `employee_sex` char(1) NOT NULL DEFAULT '0' COMMENT '字典 sys_user_sex',
  `employee_address` varchar(200) NOT NULL DEFAULT '' COMMENT '地址',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB  COMMENT='雇员表';

-- ----------------------------
-- Records of agriculture_employee
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_employee` (`employee_id`, `employee_code`, `employee_name`, `employee_type`, `employee_tel`, `employee_sex`, `employee_address`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '1001', '张三', '0', '1', '0', '江苏省盐城市', '', '0', 0, 0, '2023-05-17 13:57:38', 0, '2023-05-17 16:10:50', '0');
INSERT INTO `agriculture_employee` (`employee_id`, `employee_code`, `employee_name`, `employee_type`, `employee_tel`, `employee_sex`, `employee_address`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '002', '李四', '0', '18112857630', '0', '123', '', '0', 0, 1, '2023-05-18 09:16:02', 0, NULL, '2');
INSERT INTO `agriculture_employee` (`employee_id`, `employee_code`, `employee_name`, `employee_type`, `employee_tel`, `employee_sex`, `employee_address`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '002', '乔军', '0', '18112857630', '0', '盐城市', '', '0', 0, 1, '2023-06-12 14:18:44', 0, NULL, '0');
INSERT INTO `agriculture_employee` (`employee_id`, `employee_code`, `employee_name`, `employee_type`, `employee_tel`, `employee_sex`, `employee_address`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '001', '姚琼', '0', '18111118888', '1', '高教公寓', '', '0', 0, 8, '2023-08-26 13:46:51', 0, NULL, '2');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_germplasm
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_germplasm`;
CREATE TABLE `agriculture_germplasm` (
  `germplasm_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '种质ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `crop_name` varchar(50) NOT NULL DEFAULT '' COMMENT '作物名称',
  `crop_en_name` varchar(50) NOT NULL DEFAULT '' COMMENT '作物英文名称',
  `germplasm_name` varchar(50) NOT NULL DEFAULT '' COMMENT '种质名称',
  `germplasm_en_name` varchar(50) NOT NULL DEFAULT '' COMMENT '种质英文名称',
  `germplasm_img` varchar(100) NOT NULL DEFAULT '' COMMENT '种质图片',
  `germplasm_des` varchar(500) NOT NULL DEFAULT '' COMMENT '宣传语',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`germplasm_id`)
) ENGINE=InnoDB  COMMENT='种质表';

-- ----------------------------
-- Records of agriculture_germplasm
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_germplasm` (`germplasm_id`, `crop_name`, `crop_en_name`, `germplasm_name`, `germplasm_en_name`, `germplasm_img`, `germplasm_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '西瓜', 'watermelon', '西瓜', 'watermelon', '/profile/iot/1/2023-0803-095310.png', '西瓜是一种夏季消暑的好选择，其含有丰富的水分和天然的清凉成分，能够有效地降低体温。除了降热解暑，西瓜皮还可以用来炒着吃或伴着吃，制成药材来治疗肾炎水肿、肝病黄疸等疾病，甚至可以作为美容材料用来敷脸。因此，夏季食用西瓜不仅能够解暑，还能保持身体健康。', '1', '0', 0, 1, '2023-05-18 09:35:37', 1, '2023-08-03 09:53:12', '0');
INSERT INTO `agriculture_germplasm` (`germplasm_id`, `crop_name`, `crop_en_name`, `germplasm_name`, `germplasm_en_name`, `germplasm_img`, `germplasm_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '番茄', 'tomato', '番茄', 'tomato', '/profile/iot/1/2023-0803-095406.png', '1212', '', '0', 0, 1, '2023-05-23 21:01:12', 1, '2023-08-03 09:54:08', '0');
INSERT INTO `agriculture_germplasm` (`germplasm_id`, `crop_name`, `crop_en_name`, `germplasm_name`, `germplasm_en_name`, `germplasm_img`, `germplasm_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '胡萝卜', 'carrot', '胡萝卜', 'carrot', '/profile/iot/1/2023-0803-095052.png', '胡萝卜（Daucus carota var. sativa Hoffm.），是伞形科胡萝卜属一年生或二年生草本植物。转基因胡萝卜：表面较光滑。胡萝卜根肉质，长圆锥形，呈橙红色或黄色；茎单生，全株被白色粗硬毛；叶片长圆形，先端尖锐；茎生叶近无柄，有叶鞘，末回裂片小或细长；花通常白色，有时带淡红色；花柄不等长；', '', '0', 0, 1, '2023-08-03 09:51:18', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_germplasm_intro
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_germplasm_intro`;
CREATE TABLE `agriculture_germplasm_intro` (
  `intro_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '介绍ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `germplasm_id` bigint(20) NOT NULL COMMENT '种质ID',
  `intro_name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `intro_img` varchar(100) NOT NULL DEFAULT '' COMMENT '图片',
  `intro_des` varchar(1000) NOT NULL DEFAULT '' COMMENT '描述',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`intro_id`)
) ENGINE=InnoDB  COMMENT='种质介绍表';

-- ----------------------------
-- Records of agriculture_germplasm_intro
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_germplasm_intro` (`intro_id`, `germplasm_id`, `intro_name`, `intro_img`, `intro_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 2, '1', '/profile/iot/1/2023-0523-215817.png', '111', '', '0', 0, 0, '2023-05-23 21:58:19', 0, NULL, '0');
INSERT INTO `agriculture_germplasm_intro` (`intro_id`, `germplasm_id`, `intro_name`, `intro_img`, `intro_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 2, '121', '/profile/iot/1/2023-0523-220029.png', '1121', '', '0', 0, 0, '2023-05-23 22:00:32', 0, NULL, '0');
INSERT INTO `agriculture_germplasm_intro` (`intro_id`, `germplasm_id`, `intro_name`, `intro_img`, `intro_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 1, '介绍测试', '/profile/iot/1/2023-0524-135509.png', '111', '', '0', 0, 0, '2023-05-24 13:55:12', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_land
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_land`;
CREATE TABLE `agriculture_land` (
  `land_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '地块ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `create_dept` bigint DEFAULT NULL,
  `land_name` varchar(50) NOT NULL DEFAULT '' COMMENT '地块名称',
  `land_type` char(1) NOT NULL DEFAULT '0' COMMENT '字典 agriculture_land_type',
  `land_area` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '地块面积',
  `stroke_weight` tinyint(4) NOT NULL DEFAULT '0' COMMENT '边框宽度',
  `stroke_color` varchar(50) NOT NULL DEFAULT '' COMMENT '边框颜色',
  `stroke_opacity` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '边框透明度',
  `land_path` varchar(1000) NOT NULL DEFAULT '' COMMENT '地块路径',
  `fill_color` varchar(50) NOT NULL DEFAULT '' COMMENT '地块背景颜色',
  `fill_opacity` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '地块透明度',
  `current_batch` bigint(20) NOT NULL DEFAULT '0' COMMENT '当前种植批次',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`land_id`)
) ENGINE=InnoDB COMMENT='地块表';

-- ----------------------------
-- Records of agriculture_land
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '地块001', '1', 111.00, 2, '#00ff15', 0.50, '120.145799,33.351667|120.150085,33.354226|120.152604,33.351358|120.148145,33.348906', '#D70F0F', 0.60, 0, '', '0', 0, 0, '2023-05-12 16:37:25', 1, '2023-09-26 17:16:15', '0');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '123345', '0', 123.00, 1, '#1AC233', 0.80, '120.15169,33.348942|120.154629,33.351093|120.157398,33.347777|120.152527,33.346271', '#7DE794', 0.80, 0, '', '0', 0, 1, '2023-05-18 09:23:26', 1, '2023-05-18 09:24:03', '2');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '地块002', '0', 1.00, 2, '#6574CC', 0.80, '120.148106,33.348788|120.152634,33.351334|120.155853,33.347587|120.151711,33.344791', '#1EDA1A', 0.80, 0, '', '0', 0, 1, '2023-05-18 09:23:44', 1, '2023-09-14 10:35:43', '0');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '地块003', '0', 123.00, 1, '#1AC233', 0.80, '120.150231,33.354328|120.154769,33.356976|120.157149,33.354095|120.15268,33.351579', '#E6AA13', 0.80, 0, '', '0', 0, 1, '2023-05-18 09:23:52', 1, '2023-08-22 14:17:39', '0');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, '地块004', '0', 300.00, 1, '#1AC233', 0.80, '120.15289,33.351475|120.156085,33.347673|120.160368,33.351006|120.157293,33.354125', '#15DEB6', 0.80, 0, '', '0', 0, 1, '2023-08-02 15:48:57', 1, '2023-09-23 09:21:56', '0');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, '大棚001', '1', 30.00, 1, '#1AC233', 0.80, '120.145596,33.347267|120.146282,33.346317|120.148578,33.347895|120.147956,33.348647', '#52DC70', 0.80, 0, '', '0', 0, 1, '2023-08-22 14:06:39', 1, '2024-04-09 17:30:06', '0');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, '大棚001', '1', 10.00, 1, '#1AC233', 0.80, '120.151411,33.349683|120.152162,33.349002|120.155617,33.351529|120.154973,33.35212', '#094015', 0.80, 0, '', '0', 0, 1, '2024-01-24 10:09:13', 0, NULL, '2');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, '11', '0', 222.00, 1, '#1AC233', 0.80, '', '#094015', 0.80, 0, '', '0', 0, 1, '2024-04-09 14:59:13', 0, NULL, '2');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, '1', '0', 100.00, 1, '#1AC233', 0.80, '', '#094015', 0.80, 0, '', '0', 0, 1, '2024-04-09 17:08:56', 1, '2024-04-09 17:22:29', '2');
INSERT INTO `agriculture_land` (`land_id`, `land_name`, `land_type`, `land_area`, `stroke_weight`, `stroke_color`, `stroke_opacity`, `land_path`, `fill_color`, `fill_opacity`, `current_batch`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, '1', '0', 111.00, 1, '#1AC233', 0.80, '120.151947,33.350561|120.15493,33.351224|120.157269,33.348679|120.152505,33.347335', '#094015', 0.80, 0, '', '0', 0, 1, '2024-04-09 17:22:45', 1, '2024-04-09 17:49:27', '2');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_machine_info
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_machine_info`;
CREATE TABLE `agriculture_machine_info` (
  `machine_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '机械ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `machine_code` varchar(20) NOT NULL DEFAULT '' COMMENT '机械编码',
  `machine_name` varchar(50) NOT NULL DEFAULT '' COMMENT '机械名称',
  `machine_type_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '机械类别',
  `measure_unit` varchar(10) NOT NULL DEFAULT '' COMMENT '计量单位',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`machine_id`)
) ENGINE=InnoDB  COMMENT='机械信息表';

-- ----------------------------
-- Records of agriculture_machine_info
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_machine_info` (`machine_id`, `machine_code`, `machine_name`, `machine_type_id`, `measure_unit`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '001', '东方红拖拉机001', 1, '辆', '', '0', 0, 1, '2023-06-13 09:30:20', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_machine_type
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_machine_type`;
CREATE TABLE `agriculture_machine_type` (
  `machine_type_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '机械类别ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `machine_type_name` varchar(50) NOT NULL DEFAULT '' COMMENT '机械类别名称',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`machine_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='机械类别表';

-- ----------------------------
-- Records of agriculture_machine_type
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_machine_type` (`machine_type_id`, `machine_type_name`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '拖拉机', '2', '0', 3, 1, '2023-06-02 21:25:43', 1, '2023-06-13 09:29:33', '0');
INSERT INTO `agriculture_machine_type` (`machine_type_id`, `machine_type_name`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '收割机', '', '0', 4, 1, '2023-06-13 09:29:38', 1, '2024-05-07 11:42:59', '0');
INSERT INTO `agriculture_machine_type` (`machine_type_id`, `machine_type_name`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '插秧机', '', '0', 0, 1, '2023-06-13 09:29:43', 0, NULL, '0');
INSERT INTO `agriculture_machine_type` (`machine_type_id`, `machine_type_name`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '无人机', '', '0', 0, 8, '2023-08-26 13:41:04', 0, NULL, '2');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_material_info
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_material_info`;
CREATE TABLE `agriculture_material_info` (
  `material_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '农资ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `material_code` varchar(20) NOT NULL DEFAULT '' COMMENT '农资编码',
  `material_name` varchar(50) NOT NULL DEFAULT '' COMMENT '农资名称',
  `material_type_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '农资类别',
  `measure_unit` varchar(10) NOT NULL DEFAULT '' COMMENT '计量单位',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`material_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='农资信息表';

-- ----------------------------
-- Records of agriculture_material_info
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_material_info` (`material_id`, `material_code`, `material_name`, `material_type_id`, `measure_unit`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '001', '钾肥', 1, '袋', '', '0', 0, 1, '2023-06-13 09:41:12', 0, NULL, '0');
INSERT INTO `agriculture_material_info` (`material_id`, `material_code`, `material_name`, `material_type_id`, `measure_unit`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '002', '磷肥', 1, '袋', '', '0', 0, 1, '2023-06-13 09:41:29', 0, NULL, '0');
INSERT INTO `agriculture_material_info` (`material_id`, `material_code`, `material_name`, `material_type_id`, `measure_unit`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '003', '镰刀', 2, '把', '', '0', 0, 1, '2023-06-13 09:41:45', 0, NULL, '0');
INSERT INTO `agriculture_material_info` (`material_id`, `material_code`, `material_name`, `material_type_id`, `measure_unit`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '004', '大镰刀', 2, '把', '', '0', 0, 1, '2023-06-13 09:46:52', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_material_type
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_material_type`;
CREATE TABLE `agriculture_material_type` (
  `material_type_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '农资类别ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `material_type_name` varchar(50) NOT NULL DEFAULT '' COMMENT '农资类别名称',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`material_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='农资类别表';

-- ----------------------------
-- Records of agriculture_material_type
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_material_type` (`material_type_id`, `material_type_name`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '肥料', '', '0', 2, 1, '2023-06-13 09:40:21', 1, '2024-05-07 11:42:04', '0');
INSERT INTO `agriculture_material_type` (`material_type_id`, `material_type_name`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '镰刀', '', '0', 1, 1, '2023-06-13 09:40:46', 1, '2024-05-07 11:42:09', '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_plant_method
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_plant_method`;
CREATE TABLE `agriculture_plant_method` (
  `method_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '方法ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `germplasm_id` bigint(20) NOT NULL COMMENT '种质ID',
  `method_name` varchar(50) NOT NULL DEFAULT '' COMMENT '名称',
  `method_img` varchar(100) NOT NULL DEFAULT '' COMMENT '图片',
  `method_des` varchar(1000) NOT NULL DEFAULT '' COMMENT '描述',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`method_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='种植方法表';

-- ----------------------------
-- Records of agriculture_plant_method
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_plant_method` (`method_id`, `germplasm_id`, `method_name`, `method_img`, `method_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 1, '方法2222', '/profile/iot/1/2023-0523-211723.png', '是的撒的撒的', '', '0', 0, 0, '2023-05-23 20:58:40', 0, '2023-05-24 13:55:47', '0');
INSERT INTO `agriculture_plant_method` (`method_id`, `germplasm_id`, `method_name`, `method_img`, `method_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 2, '方法', '/profile/iot/1/2023-0523-214207.png', '猜猜猜', '', '0', 0, 0, '2023-05-23 21:42:12', 0, '2023-05-24 13:55:34', '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_standard_job
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_standard_job`;
CREATE TABLE `agriculture_standard_job` (
  `job_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '作业任务ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `germplasm_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '种质ID',
  `job_name` varchar(50) NOT NULL DEFAULT '' COMMENT '作业任务名称',
  `cycle_unit` char(1) NOT NULL DEFAULT '0' COMMENT '作业周期单位（0代表周 1代表天）',
  `job_start` int(11) NOT NULL DEFAULT '0' COMMENT '起始周/天',
  `job_finish` int(11) NOT NULL DEFAULT '0' COMMENT '结束周/天',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='标准作业任务表';

-- ----------------------------
-- Records of agriculture_standard_job
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 2, '播种', '1', 1, 3, '', '0', 0, 1, '2023-05-25 22:15:16', 1, '2023-05-30 09:37:59', '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 2, '浇水', '1', 2, 4, '', '0', 0, 1, '2023-05-30 09:38:25', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 2, '采摘', '1', 5, 6, '', '0', 0, 1, '2023-05-30 09:38:47', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 1, '育苗', '1', 1, 3, '', '0', 0, 1, '2023-05-30 17:40:31', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 1, '铺膜', '1', 3, 4, '', '0', 0, 1, '2023-05-30 17:41:18', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 1, '育苗完成', '1', 5, 6, '', '0', 0, 1, '2023-05-30 17:41:39', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, 1, '定植', '1', 6, 7, '', '0', 0, 1, '2023-05-30 17:41:56', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, 1, '植保防护', '1', 7, 8, '', '0', 0, 1, '2023-05-30 17:42:25', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, 1, '授粉', '1', 9, 10, '', '0', 0, 1, '2023-05-30 17:42:49', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, 1, '修剪侧蔓', '1', 11, 12, '', '0', 0, 1, '2023-05-30 17:45:54', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (11, 1, '坐果期', '1', 12, 13, '', '0', 0, 1, '2023-05-30 17:46:13', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12, 1, '膨果期', '1', 13, 14, '', '0', 0, 1, '2023-05-30 17:46:37', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (13, 1, '结果期', '1', 14, 15, '', '0', 0, 1, '2023-05-30 17:46:52', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (14, 1, '采摘', '1', 15, 16, '', '0', 0, 1, '2023-05-30 17:47:29', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (15, 1, '作业流程', '0', 1, 2, '', '0', 0, 8, '2023-08-26 14:11:15', 0, NULL, '2');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (16, 3, '播种', '1', 1, 1, '', '0', 0, 1, '2023-09-05 12:53:54', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (17, 3, '收获', '1', 2, 2, '', '0', 0, 1, '2023-09-05 12:54:10', 0, NULL, '0');
INSERT INTO `agriculture_standard_job` (`job_id`, `germplasm_id`, `job_name`, `cycle_unit`, `job_start`, `job_finish`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (18, 1, '测试', '0', 30, 40, '', '0', 0, 1, '2024-03-15 14:19:42', 0, NULL, '2');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_task_employee
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_task_employee`;
CREATE TABLE `agriculture_task_employee` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `task_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `employee_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '雇员ID',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='批次任务工人表';

-- ----------------------------
-- Table structure for agriculture_task_log
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_task_log`;
CREATE TABLE `agriculture_task_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `task_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `oper_name` varchar(50) NOT NULL DEFAULT '' COMMENT '操作人名称',
  `oper_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作人Id',
  `oper_des` varchar(500) NOT NULL DEFAULT '' COMMENT '操作描述',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='批次任务日志表';


-- ----------------------------
-- Table structure for agriculture_trace_code
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_code`;
CREATE TABLE `agriculture_trace_code` (
  `code_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '溯源码ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `sellpro_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  `version_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '溯源版本ID',
  `trace_code` varchar(500) NOT NULL DEFAULT '' COMMENT '溯源码',
  `trace_url` varchar(500) NOT NULL DEFAULT '' COMMENT '溯源链接',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '2' COMMENT '状态 1可用 2不可用 trace_status',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`code_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12168 DEFAULT CHARSET=utf8 COMMENT='溯源码表';

-- ----------------------------
-- Records of agriculture_trace_code
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12157, 12, 10, 'frog20240429231816000007', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000007', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12158, 12, 10, 'frog20240429231816000008', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000008', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12159, 12, 10, 'frog20240429231816000009', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000009', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12160, 12, 10, 'frog20240429231816000010', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000010', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12161, 12, 10, 'frog20240429231816000011', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000011', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12162, 12, 10, 'frog20240429231816000012', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000012', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12163, 12, 10, 'frog20240429231816000013', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000013', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12164, 12, 10, 'frog20240429231816000014', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000014', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12165, 12, 10, 'frog20240429231816000015', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000015', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12166, 12, 10, 'frog20240429231816000016', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000016', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
INSERT INTO `agriculture_trace_code` (`code_id`, `sellpro_id`, `version_id`, `trace_code`, `trace_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12167, 12, 10, 'frog20240429231816000017', 'http://192.168.3.110:1024/preview?traceCode=frog20240429231816000017', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_trace_code_template
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_code_template`;
CREATE TABLE `agriculture_trace_code_template` (
  `template_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '模版ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `template_name` varchar(255) NOT NULL DEFAULT '' COMMENT '模版名称',
  `template_bgi` varchar(100) NOT NULL DEFAULT '' COMMENT '模版背景图',
  `template_width` int(10) NOT NULL DEFAULT '0' COMMENT '模版宽度(PX)',
  `template_height` int(10) NOT NULL DEFAULT '0' COMMENT '模版高度(PX)',
  `qrcode_width` int(10) NOT NULL DEFAULT '0' COMMENT '二维码宽度(PX)',
  `qrcode_height` int(10) NOT NULL DEFAULT '0' COMMENT '二维码高度(PX)',
  `qrcode_x` int(10) NOT NULL DEFAULT '0' COMMENT '二维码横坐标位置(PX)',
  `qrcode_y` int(10) NOT NULL DEFAULT '0' COMMENT '二维码纵坐标位置(PX)',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态（0可用，2不可用）',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `base_coordinate` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='溯源码模版表';

-- ----------------------------
-- Records of agriculture_trace_code_template
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_code_template` (`template_id`, `template_name`, `template_bgi`, `template_width`, `template_height`, `qrcode_width`, `qrcode_height`, `qrcode_x`, `qrcode_y`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (3, '', '/profile/iot/1/2024-0402-171201.jpg', 1, 2, 3, 4, 5, 6, '', '0', 0, 1, '2024-04-02 17:12:09', 0, NULL, '2', '');
INSERT INTO `agriculture_trace_code_template` (`template_id`, `template_name`, `template_bgi`, `template_width`, `template_height`, `qrcode_width`, `qrcode_height`, `qrcode_x`, `qrcode_y`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (4, '', '/profile/iot/1/2024-0407-162232.png', 400, 300, 66, 63, 313, 224, '', '0', 0, 1, '2024-04-07 16:23:20', 0, NULL, '2', '');
INSERT INTO `agriculture_trace_code_template` (`template_id`, `template_name`, `template_bgi`, `template_width`, `template_height`, `qrcode_width`, `qrcode_height`, `qrcode_x`, `qrcode_y`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (5, '模版1', '/profile/iot/1/2024-0418-160042.png', 640, 422, 90, 90, 277, 184, '', '2', 0, 1, '2024-04-12 11:18:16', 1, '2024-04-20 14:42:10', '0', '');
INSERT INTO `agriculture_trace_code_template` (`template_id`, `template_name`, `template_bgi`, `template_width`, `template_height`, `qrcode_width`, `qrcode_height`, `qrcode_x`, `qrcode_y`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (6, '模版2', '/profile/iot/1/2024-0420-141515.png', 400, 300, 86, 86, 95, 187, '', '0', 0, 1, '2024-04-12 11:44:55', 1, '2024-04-29 23:18:08', '0', '');
INSERT INTO `agriculture_trace_code_template` (`template_id`, `template_name`, `template_bgi`, `template_width`, `template_height`, `qrcode_width`, `qrcode_height`, `qrcode_x`, `qrcode_y`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (7, '模版3', '/profile/iot/1/2024-0418-161942.png', 640, 422, 40, 40, 0, 0, '', '0', 0, 1, '2024-04-18 16:19:47', 1, '2024-04-18 16:42:45', '0', '');
INSERT INTO `agriculture_trace_code_template` (`template_id`, `template_name`, `template_bgi`, `template_width`, `template_height`, `qrcode_width`, `qrcode_height`, `qrcode_x`, `qrcode_y`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (8, '测试模版2', '/profile/iot/1/2024-0420-220457.png', 400, 300, 132, 132, 158, 100, '', '0', 0, 1, '2024-04-20 22:05:11', 0, NULL, '0', '');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_trace_record
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_record`;
CREATE TABLE `agriculture_trace_record` (
  `record_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `sellpro_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  `trace_code` varchar(500) NOT NULL DEFAULT '' COMMENT '溯源码',
  `query_date` datetime DEFAULT NULL COMMENT '查询时间',
  `query_address` varchar(50) NOT NULL DEFAULT '' COMMENT '查询地点',
  `query_coordinate` varchar(50) NOT NULL DEFAULT '' COMMENT '查询坐标',
  `query_city` varchar(50) NOT NULL DEFAULT '' COMMENT '查询城市',
  `city_code` varchar(50) NOT NULL DEFAULT '' COMMENT '城市代码',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '2' COMMENT '状态',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='溯源码查询记录表';


-- ----------------------------
-- Table structure for agriculture_trace_sellpro
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_sellpro`;
CREATE TABLE `agriculture_trace_sellpro` (
  `sellpro_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '产品ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `sellpro_name` varchar(20) NOT NULL DEFAULT '' COMMENT '产品名称',
  `sellpro_area` varchar(20) NOT NULL DEFAULT '' COMMENT '产地',
  `sellpro_weight` varchar(20) NOT NULL DEFAULT '' COMMENT '产品重量',
  `sellpro_guige` varchar(20) NOT NULL DEFAULT '' COMMENT '产品规格',
  `sellpro_img` varchar(500) NOT NULL DEFAULT '' COMMENT '产品图片',
  `template_id` int(11) DEFAULT NULL COMMENT '溯源页面模版ID',
  `code_template_id` bigint(20) DEFAULT NULL COMMENT '溯源码模版ID',
  `germplasm_id` varchar(100) NOT NULL DEFAULT '' COMMENT '种质ID',
  `batch_id` varchar(100) NOT NULL DEFAULT '' COMMENT '批次ID',
  `land_id` varchar(100) NOT NULL DEFAULT '' COMMENT '地块ID',
  `device_id` varchar(100) NOT NULL DEFAULT '' COMMENT '环境设备ID',
  `camera_id` varchar(100) NOT NULL DEFAULT '' COMMENT '监控设备ID',
  `staff_id` varchar(100) NOT NULL DEFAULT '' COMMENT '溯源人员ID',
  `shop_id` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺ID',
  `h5_url` varchar(500) NOT NULL DEFAULT '' COMMENT '溯源页面',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '2' COMMENT '状态 1可用 2不可用 trace_status',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`sellpro_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='溯源产品表';

-- ----------------------------
-- Records of agriculture_trace_sellpro
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0809-095959.png', NULL, NULL, '2', '41', '1', 'D12D7G548344,test02C00081A5514AB0', '146', '5', '1', 'https://trace.zosoft.top/#/pages/home/index', '本地西红柿，非常的粉', '0', 0, 1, '2023-08-07 16:53:42', 1, '2024-04-15 14:53:58', '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (11, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0807-165338.png', NULL, NULL, '2', '41', '1', '141', '141', '5', '1', 'http://baidu.com/', '', '0', 0, 1, '2023-08-07 16:53:42', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (12, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0809-100039.png', 4, 6, '2', '41', '1', 'test02C00081A5514AB0', '141', '5', '1', 'https://trace.zosoft.top/#/pages/home/index', '品种为日本进口，非常的好吃', '0', 0, 1, '2023-08-07 16:53:42', 1, '2024-04-29 23:19:30', '0');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (13, '番茄', '江苏盐城尚庄', '10KG', '10个', '/profile/iot/1/2023-0809-100143.png', NULL, NULL, '2', '41', '1', 'test02C00081A5514AB0', '141', '5', '1', 'https://trace.zosoft.top/#/pages/home/index', '美国进口品种，光照充足', '0', 0, 1, '2023-08-07 16:53:42', 1, '2023-10-08 10:18:03', '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (14, '黑金王炸', '盐城东台', '22KG', '盒', '/profile/iot/1/2023-0809-100257.png', 4, 5, '1', '41', '1', 'test02C00081A5514AB0,D12D7G548344,D1YJE0U63Y09', '141', '5', '1', 'https://trace.zosoft.top/#/pages/home/index', '皮薄，甜', '1', 0, 1, '2023-08-08 14:58:14', 1, '2024-04-18 17:33:25', '0');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (15, '测试产品', '20', '20', '20', '/profile/iot/1/2024-0415-145424.png', NULL, NULL, '', '', '', '', '', '', '', '', '20', '1', 0, 1, '2024-04-15 14:54:26', 0, NULL, '2');
INSERT INTO `agriculture_trace_sellpro` (`sellpro_id`, `sellpro_name`, `sellpro_area`, `sellpro_weight`, `sellpro_guige`, `sellpro_img`, `template_id`, `code_template_id`, `germplasm_id`, `batch_id`, `land_id`, `device_id`, `camera_id`, `staff_id`, `shop_id`, `h5_url`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (16, '2', '2', '2', '2', '/profile/iot/1/2024-0418-152957.png', NULL, NULL, '', '', '', '', '', '', '', '', '2', '1', 0, 1, '2024-04-18 15:29:59', 0, NULL, '2');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_trace_shop
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_shop`;
CREATE TABLE `agriculture_trace_shop` (
  `shop_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '店铺ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `shop_name` varchar(50) NOT NULL DEFAULT '' COMMENT '店铺名称',
  `shop_type` varchar(20) NOT NULL DEFAULT '0' COMMENT '店铺类型 1线上 2线下',
  `shop_img` varchar(250) NOT NULL DEFAULT '' COMMENT '店铺图片',
  `shop_address` varchar(50) NOT NULL DEFAULT '' COMMENT '店铺地址',
  `shop_coordinate` varchar(50) NOT NULL DEFAULT '' COMMENT '店铺坐标',
  `shop_contacts` varchar(20) NOT NULL DEFAULT '' COMMENT '店铺联系人',
  `shop_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '店铺联系方式',
  `shop_url` varchar(2000) NOT NULL DEFAULT '' COMMENT '店铺链接',
  `shop_des` varchar(100) NOT NULL DEFAULT '' COMMENT '店铺描述',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '2' COMMENT '状态 1可用 2不可用 trace_status',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='店铺表';

-- ----------------------------
-- Records of agriculture_trace_shop
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_shop` (`shop_id`, `shop_name`, `shop_type`, `shop_img`, `shop_address`, `shop_coordinate`, `shop_contacts`, `shop_tel`, `shop_url`, `shop_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '盐城开发区店', '1', '/profile/iot/1/2023-0802-174630.png', '盐城市开发区', '120.139974,33.353455', '乔军', '18112857630', 'https://item.taobao.com/item.htm?id=712366130554&ali_refid=a3_430673_1006:1125303001:N:emtiAWsF8%2Bzhhxaiwzc0Aw%3D%3D:1d8c5875b3f9dba8210ac36019832038&ali_trackid=162_1d8c5875b3f9dba8210ac36019832038&spm=a2e0b.20350158.31919782.2', '这是一个很好的店铺', '111', '0', 0, 1, '2023-08-02 17:49:59', 1, '2024-04-18 16:40:59', '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_trace_staff
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_staff`;
CREATE TABLE `agriculture_trace_staff` (
  `staff_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '员工ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `staff_position` varchar(50) NOT NULL DEFAULT '' COMMENT '员工职位',
  `staff_name` varchar(50) NOT NULL DEFAULT '' COMMENT '员工名称',
  `staff_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '员工联系方式',
  `staff_des` varchar(100) NOT NULL DEFAULT '' COMMENT '员工描述',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '1' COMMENT '状态 1可用 2不可用 trace_status',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`staff_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='溯源人员表';

-- ----------------------------
-- Records of agriculture_trace_staff
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '经理', '乔军', '18112857630', '非常的好', '', '0', 0, 1, '2023-08-02 21:10:29', 0, NULL, '2');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '1', '1', '1', '1', '', '0', 0, 1, '2023-08-02 21:12:34', 0, NULL, '2');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '1', '2', '3', '4', '', '0', 0, 1, '2023-08-02 21:13:45', 0, NULL, '2');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '1', '2', '3', '4', '', '2', 0, 1, '2023-08-02 21:14:50', 0, NULL, '2');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, '业务经理', '乔军', '18112857630', '一次合作终身朋友', '', '0', 0, 1, '2023-08-04 14:18:38', 1, '2024-04-18 16:30:25', '0');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, '测试', '1', '1', '1', '', '0', 0, 1, '2024-04-16 21:05:30', 1, '2024-04-18 16:30:47', '0');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, '33', '33', '33', '333', '', '0', 0, 1, '2024-04-16 21:08:20', 1, '2024-04-18 16:30:49', '0');
INSERT INTO `agriculture_trace_staff` (`staff_id`, `staff_position`, `staff_name`, `staff_tel`, `staff_des`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, '2', '2', '2', '2', '', '0', 0, 1, '2024-04-16 21:11:10', 1, '2024-04-18 16:38:52', '0');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_trace_template
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_template`;
CREATE TABLE `agriculture_trace_template` (
  `template_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '模版ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `template_name` varchar(100) NOT NULL DEFAULT '' COMMENT '模版名称',
  `template_json` json DEFAULT NULL COMMENT '模版JSON',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '0' COMMENT '状态（0可用 2不可用）',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `base_coordinate` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='溯源模版表';

-- ----------------------------
-- Records of agriculture_trace_template
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_template` (`template_id`, `template_name`, `template_json`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (3, '页面模版1', '[{\"type\": \"info\", \"title\": \"乔军标题\", \"backgroundColor\": \"rgba(255, 255, 255, 1)\"}, {\"data\": {\"text\": \"已经溯源#次\"}, \"type\": \"traceTime\", \"options\": {}}, {\"data\": [{\"remark\": \"12367呃呃呃呃444\", \"taskName\": \"播种\", \"taskImage\": \"/profile/iot/1/2023-1009-161451.png\", \"actualStart\": \"2024-04-30\", \"actualFinish\": \"2024-04-30\", \"taskHeadName\": \"乔军\"}, {\"form\": {}, \"remark\": \"施肥\", \"taskName\": \"施肥\", \"taskImage\": \"/profile/iot/1/2024-0418-111244.png\", \"actualStart\": \"2024-04-18\", \"actualFinish\": \"2024-04-26\", \"taskHeadName\": \"乔军\"}], \"type\": \"plantProgress\", \"options\": {}}, {\"data\": {\"remark\": \"皮薄，甜\", \"sellproId\": 14, \"sellproImg\": \"/profile/iot/1/2023-0809-100257.png\", \"sellproArea\": \"盐城东台\", \"sellproName\": \"黑金王炸\", \"sellproGuige\": \"盒\", \"sellproWeight\": \"22KG\"}, \"type\": \"productInfo\", \"options\": {}}, {\"data\": [{\"url\": \"/profile/iot/1/2024-0428-113742.png\", \"form\": {}, \"link\": \"\", \"name\": \"22333.png\"}, {\"url\": \"/profile/iot/1/2024-0428-113746.png\", \"form\": {}, \"link\": \"\", \"name\": \"22333.png\"}, {\"url\": \"/profile/iot/1/2024-0428-113838.png\", \"form\": {}, \"link\": \"\", \"name\": \"22333.png\"}], \"type\": \"quality\", \"options\": {}}, {\"data\": {\"name\": \"456\", \"position\": \"123\"}, \"type\": \"map\", \"options\": {}}, {\"data\": [{\"url\": \"/profile/iot/1/2024-0418-134910.png\", \"name\": \"333\", \"color\": \"#E75050\", \"value\": \"444\"}, {\"url\": \"/profile/iot/1/2024-0418-134842.png\", \"name\": \"11\", \"color\": \"#ED6262\", \"value\": \"33\"}], \"type\": \"plantEnv\", \"options\": {}}, {\"data\": [{\"staffDes\": \"2\", \"staffTel\": \"2\", \"staffName\": \"2\", \"staffPosition\": \"2\"}, {\"staffDes\": \"一次合作终身朋友\", \"staffTel\": \"18112857630\", \"staffName\": \"乔军\", \"staffPosition\": \"业务经理\"}, {\"staffDes\": \"一次合作终身朋友\", \"staffTel\": \"18112857630\", \"staffName\": \"乔军\", \"staffPosition\": \"业务经理\"}], \"type\": \"staff\", \"options\": {}}, {\"data\": [{\"shopImg\": \"/profile/iot/1/2023-0802-174630.png\", \"shopTel\": \"18112857630\", \"shopUrl\": \"https://item.taobao.com/item.htm?id=712366130554&ali_refid=a3_430673_1006:1125303001:N:emtiAWsF8%2Bzhhxaiwzc0Aw%3D%3D:1d8c5875b3f9dba8210ac36019832038&ali_trackid=162_1d8c5875b3f9dba8210ac36019832038&spm=a2e0b.20350158.31919782.2\", \"shopName\": \"盐城开发区店\", \"shopType\": \"1\", \"shopAddress\": \"盐城市开发区\", \"shopContacts\": \"乔军\"}], \"type\": \"shop\", \"options\": {}}, {\"data\": [{\"url\": \"/profile/iot/1/2024-0418-143904.png\", \"link\": \"\", \"name\": \"123.png\"}], \"type\": \"brand\", \"options\": {}}]', '2', '0', 0, 1, '2024-04-14 16:27:21', 1, '2024-04-28 11:38:44', '0', '');
INSERT INTO `agriculture_trace_template` (`template_id`, `template_name`, `template_json`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (4, '页面模版2', '[{\"type\": \"info\", \"title\": \"乔军标题\", \"backgroundColor\": \"rgba(255, 255, 255, 1)\"}, {\"data\": {\"text\": \"核验次数\", \"times\": \"\"}, \"type\": \"traceTime\", \"options\": {}}, {\"data\": [{\"remark\": \"12367呃呃呃呃444\", \"taskName\": \"播种\", \"taskImage\": \"/profile/iot/1/2023-1009-161451.png\", \"actualStart\": \"2024-04-30\", \"actualFinish\": \"2024-04-30\", \"taskHeadName\": \"乔军\"}, {\"form\": {}, \"remark\": \"施肥\", \"taskName\": \"施肥\", \"taskImage\": \"/profile/iot/1/2024-0418-111244.png\", \"actualStart\": \"2024-04-18\", \"actualFinish\": \"2024-04-26\", \"taskHeadName\": \"乔军\"}, {\"remark\": \"e记得记得就好的好的基督教xx把bv你了哈哈哈\", \"taskName\": \"播种1\", \"taskImage\": \"/profile/upload/2024/04/23/8d0f2ca0-3066-4fd4-8f9b-57d9018b2aed.jpg\", \"actualStart\": \"2024-04-26\", \"actualFinish\": \"2024-04-26\", \"taskHeadName\": \"张三\"}, {\"remark\": \"e记得记得就好的好的基督教xx把bv你了哈哈哈\", \"taskName\": \"播种1\", \"taskImage\": \"/profile/upload/2024/04/23/8d0f2ca0-3066-4fd4-8f9b-57d9018b2aed.jpg\", \"actualStart\": \"2024-04-26\", \"actualFinish\": \"2024-04-26\", \"taskHeadName\": \"张三\"}, {\"remark\": \"e记得记得就好的好的基督教xx把bv你了哈哈哈\", \"taskName\": \"播种1\", \"taskImage\": \"/profile/upload/2024/04/23/8d0f2ca0-3066-4fd4-8f9b-57d9018b2aed.jpg\", \"actualStart\": \"2024-04-26\", \"actualFinish\": \"2024-04-26\", \"taskHeadName\": \"张三\"}], \"type\": \"plantProgress\", \"options\": {}}, {\"data\": {\"remark\": \"品种为日本进口，非常的好吃\", \"sellproId\": 12, \"sellproImg\": \"/profile/iot/1/2023-0809-100039.png\", \"sellproArea\": \"江苏盐城尚庄\", \"sellproName\": \"番茄\", \"sellproGuige\": \"10个\", \"sellproWeight\": \"10KG\"}, \"type\": \"productInfo\", \"options\": {}}, {\"data\": {\"name\": \"ddddd\", \"address\": \"盐城经济技术开发去希望达到5号\", \"position\": \"120.16,33.35\"}, \"type\": \"map\", \"options\": {}}, {\"data\": [{\"url\": \"/profile/iot/1/2024-0428-113947.png\", \"form\": {}, \"link\": \"http://baidu.com\", \"name\": \"22333.png\"}, {\"url\": \"/profile/iot/1/2024-0428-113950.png\", \"form\": {}, \"link\": \"http://baidu.com\", \"name\": \"22333.png\"}, {\"url\": \"/profile/iot/1/2024-0428-114004.png\", \"form\": {}, \"link\": \"http://baidu.com\", \"name\": \"22333.png\"}], \"type\": \"quality\", \"options\": {}}, {\"data\": [{\"url\": \"/profile/iot/1/2024-0428-135502.png\", \"name\": \"压力\", \"unit\": \"℃\", \"color\": \"#E75050\", \"value\": \"32\"}, {\"url\": \"/profile/iot/1/2024-0428-135506.png\", \"name\": \"湿度\", \"unit\": \"℃\", \"color\": \"#ED6262\", \"value\": \"33\"}, {\"url\": \"/profile/iot/1/2024-0428-135514.png\", \"name\": \"光照\", \"unit\": \"us\", \"color\": \"\", \"value\": \"30\"}, {\"url\": \"/profile/iot/1/2024-0428-135520.png\", \"name\": \"湿度\", \"unit\": \"%\", \"color\": \"\", \"value\": \"100\"}, {\"url\": \"/profile/iot/1/2024-0428-135533.png\", \"name\": \"温度\", \"unit\": \"ppt\", \"color\": \"\", \"value\": \"32\"}], \"type\": \"plantEnv\", \"options\": {}}, {\"data\": [{\"staffDes\": \"一次合作终身朋友\", \"staffTel\": \"18112857630\", \"staffName\": \"乔军\", \"staffPosition\": \"业务经理\"}, {\"staffDes\": \"一次合作终身朋友\", \"staffTel\": \"18112857630\", \"staffName\": \"乔军\", \"staffPosition\": \"业务经理\"}], \"type\": \"staff\", \"options\": {}}, {\"data\": [{\"shopImg\": \"/profile/iot/1/2023-0802-174630.png\", \"shopTel\": \"18112857630\", \"shopUrl\": \"https://item.taobao.com/item.htm?id=712366130554&ali_refid=a3_430673_1006:1125303001:N:emtiAWsF8%2Bzhhxaiwzc0Aw%3D%3D:1d8c5875b3f9dba8210ac36019832038&ali_trackid=162_1d8c5875b3f9dba8210ac36019832038&spm=a2e0b.20350158.31919782.2\", \"shopName\": \"盐城开发区店\", \"shopType\": \"1\", \"shopAddress\": \"盐城市开发区\", \"shopContacts\": \"乔军\"}], \"type\": \"shop\", \"options\": {}}, {\"data\": [{\"url\": \"/profile/iot/1/2024-0428-143521.jpg\", \"link\": \"http://baidu.com\", \"name\": \"7.jpg\"}], \"type\": \"brand\", \"options\": {}}]', '123', '0', 0, 1, '2024-04-15 10:14:36', 1, '2024-04-30 14:27:14', '0', '');
INSERT INTO `agriculture_trace_template` (`template_id`, `template_name`, `template_json`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`, `base_coordinate`) VALUES (5, '页面模版3', '[{\"type\": \"info\", \"title\": \"\", \"backgroundColor\": \"\"}, {\"data\": [{\"remark\": \"12367呃呃呃呃444\", \"taskName\": \"播种\", \"taskImage\": \"/profile/iot/1/2023-1009-161451.png\", \"actualStart\": null, \"actualFinish\": null, \"taskHeadName\": null}], \"type\": \"plantProgress\", \"options\": {}}]', '用于西瓜', '0', 0, 1, '2024-04-30 14:32:28', 1, '2024-04-30 15:57:08', '0', '');
COMMIT;

-- ----------------------------
-- Table structure for agriculture_trace_version
-- ----------------------------
DROP TABLE IF EXISTS `agriculture_trace_version`;
CREATE TABLE `agriculture_trace_version` (
  `version_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '溯源版本ID',
  `tenant_id` varchar(20) default '000000'comment '租户编号',
  `sellpro_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '产品ID',
  `code_range` varchar(250) NOT NULL DEFAULT '' COMMENT '溯源版本编号',
  `remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '备注',
  `status` char(1) NOT NULL DEFAULT '2' COMMENT '状态 1可用 2不可用 trace_status',
  `order_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint(20) DEFAULT '0' COMMENT '修改人ID',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='溯源版本表';

-- ----------------------------
-- Records of agriculture_trace_version
-- ----------------------------
BEGIN;
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 12, 'frog20240419205441000001-frog20240419205441000005', '', '0', 0, 1, '2024-04-19 20:54:42', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 14, 'frog20240419205446000001-frog20240419205446000015', '', '0', 0, 1, '2024-04-19 20:54:47', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, 14, 'frog20240419210341000001-frog20240419210341000006', '', '0', 0, 1, '2024-04-19 21:03:41', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, 12, 'frog20240420141955000001-frog20240420141955000100', '', '0', 0, 1, '2024-04-20 14:19:55', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (5, 12, 'frog20240420142152000001-frog20240420142152010000', '', '0', 0, 1, '2024-04-20 14:21:52', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (6, 12, 'frog20240420142712000001-frog20240420142712001000', '', '0', 0, 1, '2024-04-20 14:27:13', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (7, 12, 'frog20240420223824000001-frog20240420223824001000', '', '0', 0, 1, '2024-04-20 22:38:25', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (8, 12, 'frog20240429231309000001-frog20240429231309000011', '', '0', 0, 1, '2024-04-29 23:13:10', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (9, 12, 'frog20240429231448000001-frog20240429231448000013', '', '0', 0, 1, '2024-04-29 23:14:49', 0, NULL, '0');
INSERT INTO `agriculture_trace_version` (`version_id`, `sellpro_id`, `code_range`, `remark`, `status`, `order_num`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (10, 12, 'frog20240429231816000001-frog20240429231816000017', '', '0', 0, 1, '2024-04-29 23:18:17', 0, NULL, '0');
COMMIT;
